<? include"koneksi/koneksi.php"; ?>
<? include ("lib/inc_kdauto.php");?>

<script type="text/javascript" src="admin/styless/ewp.js"></script>
<script type="text/javascript" src="admin/styless/ewp1.js"></script>
<script type="text/javascript" src="admin/calendarDateInput.js"></script>


<style type="text/css"></style>
<link href="lib/styles.css" rel="stylesheet" type="text/css">
<link href="lib/tbl_css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style28 {color: #FFFFFF; }
-->
</style>
<script type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_validateForm() { //v4.0
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
    if (val) { nm=val.name; if ((val=val.value)!="") {
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
      } else if (test!='R') { num = parseFloat(val);
        if (isNaN(val)) errors+='- '+nm+' harus berisi angka.\n';
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
          min=test.substring(8,p); max=test.substring(p+1);
          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' harus diperbaiki.\n'; }
  } if (errors) alert('Maaf data tidak boleh kosong :\n'+errors);
  document.MM_returnValue = (errors == '');
}
//-->
</script>
<div class="page-header">
  <h1><i class="fa fa-mortar-board"></i> Training</h1>
</div>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td valign="top"><table width="99%" border="1" align="center" style="border-collapse: collapse;" bordercolor="#cccccc">
  <tr bgcolor="#660066" class="FOOTWARNA">
    <td width="3%" id="tdUp"><div align="center" class="style28">No</div></td>
    <td width="14%" id="tdUp"><span class="style28">Kelompok</span></td>
    <td width="9%" id="tdUp"><div align="center" class="style28">Materi</div></td>
    <td width="13%" id="tdUp"><div align="center" class="style28">Nama instruktur</div></td>
    <td width="13%" id="tdUp"><div align="center" class="style28">Tanggal Training</div></td>
    <td width="15%" id="tdUp"><div align="center" class="style28">Quota Peserta</div></td>
    <td width="12%" id="tdUp"><div align="center" class="style28">Jumlah Peserta</div></td>
    </tr>
  <tr>
<? include"koneksi/koneksi.php";
 $limit=15;
 if(empty($halaman)){
 $offset=0;
 $halaman=1;}
 else{
 $offset=($halaman-1) * $limit; }
 
$lihat=mysql_query("select * from instruktur i,materi m,training t, jobdesc_kualifikasi jk,karyawan k, kelompok km, jobdesc jb
					where jk.kd_materi=m.kd_materi and t.kd_instruktur=i.kd_instruktur  and km.kd_kelompok=jb.kd_kelompok 
					and jb.kd_jobdesc=jk.kd_jobdesc
					and k.nik=i.nik
					and jk.nodet_jobdesc=t.nodet_jobdesc
					limit $offset,$limit");
 while($hs=mysql_fetch_array($lihat))
 {
 	if($j==0){
	echo"<tr id='tampil'>";
	$j++;}
	else{
	echo"<tr id='tampil2'>";
	$j--;}
	$no++;
?> 



    <td><div align="center"><? echo"$no"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_kelompok]"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_materi]"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_karyawan]"; ?></td>
    <td><div align="center"><? echo"$hs[tgl_training]"; ?></div></td>
    <td><div align="center"><? echo"$hs[quota_peserta]"; ?></div></td>
    <td>
	  <div align="center">
	    <?
	$cek=mysql_query("select k.nik from detail_training dt, training t,karyawan k 
				  where dt.no_training=t.no_training and k.nik=dt.nik and t.no_training='$hs[no_training]'");
	//$cek_hit=mysql_fetch_array($cek);
	$cek_hit=mysql_num_rows($cek);
	{ echo"$cek_hit"; }			   
	?> </div></td>
    </tr>
  <? } ?>
</table>

<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="style12">
  <tr>
    <td><?
$lihat2=mysql_query("select * from instruktur i,materi m,training t, jobdesc_kualifikasi jk
					where jk.kd_materi=m.kd_materi and t.kd_instruktur=i.kd_instruktur and jk.nodet_jobdesc=t.nodet_jobdesc");
$jumbaris=mysql_num_rows($lihat2);
$total_halaman=ceil($jumbaris/$limit);

if(!empty($halaman) && $halaman!=1)
	{
	$previous=$halaman-1;
	echo"<a href=?act=training&halaman=$previous>Previous</a> -";
	}
	else{
	echo"Previous -";
	}

for($i=1;$i<=$total_halaman;$i++)
if($i!=$halaman)
	{
	echo"<a href=?act=training&halaman=$i>$i</a> -";
	}
	else{
	echo"$i -"; }

if($halaman<$total_halaman)
	{
	$next=$halaman+1;
	echo"<a href=?act=training&halaman=$next>Next</a>";
	echo"<center>Jumlah Data : $jumbaris</center>"; }
	else{
	echo"Next";
	echo"<center>Jumlah Data : $jumbaris</center>"; }
?>
    </td>
  </tr>
</table>
	
	</td>
  </tr>
  <tr>
    <td><p>&nbsp;</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>